package kr.co.kiso.usr.bd.ma.dao;

import java.util.List;
import java.util.Map;

import kr.co.kiso.usr.bd.ma.vo.BDMAVo;
import kr.co.kiso.usr.common.BaseDao;

import org.springframework.stereotype.Repository;

@Repository
public class BDMADao extends BaseDao {

	@SuppressWarnings("unchecked")
	public List bdma010Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("bdma.bdma010Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List bdma011Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("bdma.bdma011Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int bdma010Q_cnt(BDMAVo vo) throws Exception {
		return (Integer) getSqlMapClientTemplate().queryForObject(
				"bdma.bdma010Q_cnt", vo);
	}

	@SuppressWarnings("unchecked")
	public int bdma020Q() throws Exception {
		return (Integer)getSqlMapClientTemplate().queryForObject("bdma.bdma020Q");
	}

	@SuppressWarnings("unchecked")
	public void bdma020T(BDMAVo vo) throws Exception {
		getSqlMapClientTemplate().insert("bdma.bdma020T", vo);
	}

	@SuppressWarnings("unchecked")
	public int bdma021Q(BDMAVo vo) throws Exception {
		return (Integer)getSqlMapClientTemplate().queryForObject("bdma.bdma021Q", vo);
	}

	@SuppressWarnings("unchecked")
	public void bdma021T(BDMAVo vo) throws Exception {
		getSqlMapClientTemplate().insert("bdma.bdma021T", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public List bdma040Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("bdma.bdma040Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public int bdma041t(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().delete("bdma.bdma041t", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int bdma042t(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().delete("bdma.bdma042t", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int bdma043t(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().delete("bdma.bdma043t", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public Map bdma050Q(BDMAVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("bdma.bdma050Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List bdma051Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("bdma.bdma051Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public List bdma052Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("bdma.bdma052Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public Map bdma053Q(BDMAVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("bdma.bdma053Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public Map bdma054Q(BDMAVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("bdma.bdma054Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public int bdma060T(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().update("bdma.bdma060T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int bdma061T(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().update("bdma.bdma061T", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public List bdma061Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().queryForList("bdma.bdma061Q", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int bdma062Q(BDMAVo vo) throws Exception {
		return getSqlMapClientTemplate().delete("bdma.bdma062Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public void bdma070T(BDMAVo vo) throws Exception {
		getSqlMapClientTemplate().insert("bdma.bdma070T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public void bdma071T(BDMAVo vo) throws Exception {
		getSqlMapClientTemplate().insert("bdma.bdma071T", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public Map bdma071Q(BDMAVo vo) throws Exception {
		return (Map) getSqlMapClientTemplate().queryForObject("bdma.bdma071Q", vo);
	}
	
	
	@SuppressWarnings("unchecked")
	public int bdma080T(BDMAVo vo) throws Exception {
		return (int) getSqlMapClientTemplate().update("bdma.bdma080T", vo);
	}
	
	@SuppressWarnings("unchecked")
	public int bdma090T(BDMAVo vo) throws Exception {
		return (int) getSqlMapClientTemplate().update("bdma.bdma090T", vo);
	}
	
	
}
